Release 10.1A: OpenEdge Reporting:
Query/Results for Windows

Sort order and break groups

When you use a field to sort records in a query, Results automatically creates a break group based on the field you used to sort the records. A break group is a set of records that have a common value in a certain database field. Figure 5–4 used the Cust-Num and Order-Num fields to retrieve the orders for each customer, starting with the most recent order. Thus it contains two break groups: one for Cust-Num and one for Order-Num.

Break groups are useful because they allow you to perform calculations on a subset of records in the query. For example, you can count the number of orders for each individual customer or even calculate the total Extended-Price for the items each customer ordered. See the "Creating aggregate totals and subtotals" section for more information about performing calculations on break groups.